﻿<?php
	include("../includes/db_connect.php");
	
	mysqli_query($db, "DELETE FROM class");
	mysqli_query($db, "ALTER TABLE 'class' auto_increment = 1");
	
	mysqli_query($db, "DELETE FROM courses");
	mysqli_query($db, "ALTER TABLE 'courses' auto_increment = 1");
	
	mysqli_query($db, "DELETE FROM grades");
	
	mysqli_query($db, "DELETE FROM pages WHERE id > '20'");
	mysqli_query($db, "ALTER TABLE 'pages' auto_increment = 21");
	
	mysqli_query($db, "DELETE FROM group_rights WHERE groupId > '1'");
	mysqli_query($db, "ALTER TABLE 'group_rights' auto_increment = 12");
	
	mysqli_query($db, "DELETE FROM user_groups WHERE id > '1'");
	mysqli_query($db, "ALTER TABLE 'user_groups' auto_increment = 2");
?>